package usbcali.edu.co.pqrs.dataaccess.dao;

import java.util.List;

import javax.annotation.Resource;

import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.transform.Transformers;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Repository;

import usbcali.edu.co.pqrs.dataaccess.api.HibernateDaoImpl;
import usbcali.edu.co.pqrs.modelo.AnxsXTpSol;
import usbcali.edu.co.pqrs.modelo.dto.AnxsXTpSolDTO;

/**
 * A data access object (DAO) providing persistence and search support for
 * AnxsXTpSol entities. Transaction control of the save(), update() and delete()
 * operations can directly support Spring container-managed transactions or they
 * can be augmented to handle user-managed Spring transactions. Each of these
 * methods provides additional information for how to configure it for the
 * desired type of transaction control.
 * 
 * @see lidis.AnxsXTpSol
 */
@Scope("singleton")
@Repository("AnxsXTpSolDAO")
public class AnxsXTpSolDAO extends HibernateDaoImpl<AnxsXTpSol, Long> implements
		IAnxsXTpSolDAO {
	private static final Logger log = LoggerFactory
			.getLogger(AnxsXTpSolDAO.class);
	@Resource
	private SessionFactory sessionFactory;

	public static IAnxsXTpSolDAO getFromApplicationContext(
			ApplicationContext ctx) {
		return (IAnxsXTpSolDAO) ctx.getBean("AnxsXTpSolDAO");
	}
	
	@SuppressWarnings("unchecked")
	@Override
	public List<AnxsXTpSolDTO> traerAnexosPorNombre(String nombre) throws Exception {
		List<AnxsXTpSolDTO> listDto = null;
		try {

			Query query = getSession().getNamedQuery("anexos_por_nombre");

			query.setParameter("pNombre", nombre);
			query.setResultTransformer(Transformers.aliasToBean(AnxsXTpSolDTO.class));
			listDto = query.list();

		} catch (Exception e) {
			log.error(e.getMessage());
			throw e;
		}
		return listDto;
	}
}
